Home > Answers > How to Highlight or Remove Duplicates in Excel 2007 twa1320311909

How to Highlight or Remove Duplicates in Excel 2007?

I have an Excel file with 20K records. How do I select all entries with repeated records and then remove only the duplicated ones?
  • อุตสาหกรรม/ขอบเขต: Software
  • Category: Spreadsheet
  • Created: 04:18, 3 November 2011

Answers (1)

Joseal

For Excel 2007, this is pretty easy. Just go to the Data menu and then select Remove Duplicates from the Data Tools section on the top quick access toolbar.

05:56, 4 November 2011

คุณต้องเข้าสู่ระบบเพื่อโพสต์ข้อความสู่การอภิปราย

คำศัพท์ที่เกี่ยวข้อง

HyperCard
Software; Database applications

HyperCard was a hypermedia application that was launched by ...

DebtTracker Pro
Software; Phone apps

For those working their way out of debt, DebtTracker Pro ...

cloud computing
Computer; Servers

Cloud computing relies on sharing of resources to achieve ...

Total Recall
Software; Email

Total Recall is an email feature that allows messages sent ...

Microsoft Cortana
Software; Operating systems

Microsoft Cortana is an intelligent personal assistant on ...

RAM
Software; Operating systems

computer component where the operating system, application ...

ผู้สร้าง

Featured blossaries

Male Fashion

ประเภท: Fashion   1 8 Terms

American Library Association

ประเภท: Culture   1 16 Terms

Spanish Words For Beginners

ประเภท: Education   1 1 Terms

Game of Thrones

ประเภท: Entertainment   5 20 Terms

Famous soft drink

ประเภท: Food   1 7 Terms

Top 15 Most Beautiful Buildings Around The World

ประเภท: Arts   1 7 Terms

TermWiki is ranked top innovative application by IDC.

© 2024 CSOFT International, Ltd.   

ติดตามเราที่: